Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TenderRepositoryID (FK)(PK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | ExternalDepository(LO_EXTDST) |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
OpenMediaUnitQuantity | The opening number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL before closing a till settlement period. | QU_OPN_MD_UN | QuantityInteger | integer | |
CloseBalanceAmount | The closing system maintained tender balance in the EXTERNAL DEPOSITORY before formalizing the closing of an external depository settlement period. | MO_CL_BLNC_AMT | Money | decimal(16,5) | |
CloseMediaUnitQuantity | The closing number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the SAFE before the formal closing of a safe settlement period. | QU_CL_MD_UN | QuantityInteger | integer | |
CountedBalanceAmount | The counted tender balance in the SAFE before the fomal closing of a safe settlement period. The counted balance represents the manually counted amount that is compared to the closing balance to determine over/under variance in tender at the end of a till settlement period. | MO_CNT_BLNC_AMT | Money | decimal(16,5) | |
CountedMediaUnitQuantity | The counted number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the SAFE before the formal closing of a safe settlement period. | QU_CNT_MD_UN | QuantityInteger | integer | |
OverUnderBalanceAmount | The variance between closing balance amount and counted balance amount before the formal closing of a safe settlement period calculated by subtracting the CountedBalanceAmount from the CloseBalanceAmount A POSITIVE variance means that there is an under variance where the CLOSE balance is higher than the COUNTED balance. A NEGATIVE variance means there is an over variance where the CLOSE balance is less than the COUNTED balance (extra tender) | MO_OVR_UND_BLNC_AMT | Money | decimal(16,5) | |
OverUnderMediaUnitQuantity | The variance between closing media unit quantity and counted media unit quantity before the closing of a safe settlement period calculated by subtracting the CountedMediaUnitQuantity from the CloseMediaUnitQuantity. A POSITIVE variance means that there is an under variance where the CLOSE media unit quantity is higher than the COUNTED media unit quantity A NEGATIVE variance means there is an over variance where the CLOSE media unit quantity is less than the COUNTED media unit quantity (extra tender) | QU_OVR_UND_MD_UN | QuantityInteger | integer | |
DepositFromSafeAmount | The running sum of deposits made from store SAFES into this TENDER DEPOSITORY for the tender depository settlement period prior to the formal close of the period This is money moving from the store safe into the bank. | MO_DS_FM_SF_AMT | Money | decimal(16,5) | |
DepositFromSafeMediaUnitQuantity | The running sum of tender media unit quantities made from store SAFES into this TENDER DEPOSITORY for the tender depository settlement period prior to the formal close of the period This is money moving from the store safe into the bank. | QU_DS_FM_SF_MD_UN | QuantityInteger | integer | |
ReceiptToSafeAmount | The running sum of tender withdrawn from this external depository (bank) and received into store safes for an external depository settlement period prior to the formal closing of that period This represents tender pulled out from a bank and received into a safe for use in making change. | MO_RCT_TO_SF_AMT | Money | decimal(16,5) | |
ReceiptToSafeMediaUnitQuantity | The running sum of tender media unit quantities withdrawn from this external depository (bank) and received into store safes for an external depository settlement period prior to the formal close of that period. This represents tender pulled out from a bank and received into a safe for use in making change. | QU_RCT_TO_SF_MD_UN | QuantityInteger | integer | |